SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE dbo.[DISC_DefaultStampConfigGetByName]
	@DistributorID varchar(50),
	@Name nvarchar(255)
AS
BEGIN
	SELECT [ID], [PublisherName], [distID], [staticString], [pages], [fontName], [fontSize], [textRenderingMode], [textColor], [textStrokeColor], [strokeWidth], [placeAs], [x], [y], [units], [rotate], [opacity], [fontEmbed], [fontSubset], [stampType], [textColorSpace], [strokeColorSpace], [Name], [Description] FROM [DISC_DefaultStampConfig]
	WHERE [distID] = @DistributorID AND [Name] LIKE @Name
END
GO
